FO_MergeTable_Definitions

Table used to establish alias/cross reference of data elements for merge process since same data element might be posted to multiple tables.

 

Field Type Notes

MergeTables_ID

int

ID field, a counter. Unique

Active

bit

Bit flag to indicate if this record is active.

Enter 0 or 1

0 = inactive (FALSE)

1 = active (ACTIVE)

TableName

varchar(50)

Enter a valid database table name.

PT_ID

varchar(50)

Enter a valid column name for patient row identifier.

Do not enter a column name that is a table’s primary key, for example, for the FO_Acc_Pts or FO_Patients tables.

FOID

varchar(50)

Enter a valid column name for FOID.

MRN

varchar(50)

Enter a valid column name for MRN, medical record number.

MRNHID

varchar(50)

Enter a valid column name for MRN/Facility ID.

Acct

varchar(50)

Enter a valid column name for account.

EpisodeID

varchar(50)

Enter a valid column name for episode ID.

Do not enter a column name that is a table’s primary key, for example, for the FO_Episodes table.

LIS_Episode

varchar(50)

Enter a valid column name for lab system episode number.

SSN

varchar(50)

Enter a valid column name for social security number.

PtName

varchar(50)

Enter a valid column name for patient name.

PtDOB

varchar(50)

Enter a valid column name for patient date of birth.

PtGender

varchar(50)

Enter a valid column name for patient gender.

UniqueAcc

varchar(50)

Enter a valid column name for unique accession number.

Accession

varchar(50)

Enter a valid column name for FAST accession number.

LabAcc

varchar(50)

Enter a valid column name for lab accession number.

PIDX

varchar(50)

Enter a valid column name for lab system internal patient identifier.

ORDX

varchar(50)

Enter a valid column name for lab system internal order identifier.

FacilityID

varchar(50)

Enter a valid column name for facility ID.

CreateDate

datetime

Date record was created.

Informational

EditDate

datetime

Date record was last edited.

Informational

Last_Name

varchar(50)

Enter a valid column name for patient last name.

First_Name

varchar(50)

Enter a valid column name for patient first name.

MI

varchar(50)

Enter a valid column name for patient middle initial.